AdEnrollSched

Logical Entity Name | AdEnrollSched
Default Table Name | AdEnrollSched
Physical Only | NO
Owner | dbo
Definition |
Note |

AdEnrollSched Columns

ColumnName | Domain | Datatype | NULL | Definition
SyStudentID |  | int | NO |
AdEnrollID |  | int | NO |
AdClassSchedID |  | int | NO |
AdCourseID |  | int | NO |
AdTermID |  | int | NO |
AcademicYear |  | tinyint | NO |
Descrip |  | varchar(75) | NO |
StartDate |  | datetime | YES |
ExpectedEndDate |  | datetime | YES |
EndDate |  | datetime | YES |
LDA |  | datetime | YES |
DateGradePosted |  | datetime | YES |
DropDate |  | datetime | YES |
DateBilled |  | datetime | YES |
Extended |  | bit | NO |
ExtensionBilled |  | datetime | YES |
Status |  | char(1) | NO |
PreviousStatus |  | char(1) | YES |
Comments |  | varchar(4000) | YES |
TranscriptComment |  | nvarchar(4000) | YES |
Cost |  | money | NO |
MinutesAttended |  | int | NO |
MinutesAbsent |  | int | NO |
CostScheduled |  | bit | NO |
Credits |  | numeric(9, 2) | NO |
Hours |  | numeric(9, 2) | YES |
NumericGrade |  | numeric(11, 6) | YES |
AdGradeLetterCode |  | char(8) | NO |
RetakeFlag |  | char(1) | YES |
Speed |  | tinyint | YES |
Points |  | numeric(9, 2) | NO |
QualityPoints |  | numeric(9, 2) | YES |
CreditsAttempt |  | numeric(9, 2) | NO |
CreditsEarned |  | numeric(9, 2) | NO |
HoursAttempt |  | numeric(9, 2) | NO |
HoursEarned |  | numeric(9, 2) | NO |
GPACalc |  | bit | NO |
PayStatus |  | char(1) | YES |
ModFlag |  | char(1) | NO |
UserID |  | int | NO |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
ts |  | timestamp | NO |
AdEnrollSchedID |  | int | NO |
AdProgramCourseID |  | int | YES |
AmCollegeID |  | int | YES |
Substitute |  | bit | YES |
SubstituteAdCourseID |  | int | YES |
TransferCredit |  | bit | YES |
AdDependentClassSchedID |  | int | YES |
AutoDropFlag |  | bit | NO |
ConsecutiveMinutesAbsent |  | numeric(18, 0) | NO |
RosterFlag |  | char(2) | YES |
RevenueRefNo |  | char(8) | YES |
RetakeOverride |  | bit | NO |
AdGradeScaleID |  | int | YES |
Include |  | bit | NO |
MinutesMakeUp |  | int | NO |
DateReqMet |  | datetime | YES |
TransferredCourseCode |  | char(16) | YES |
TransferredCourseDescrip |  | varchar(75) | YES |
AdEnrollRegistrationID |  | int | YES |
DateAdvised |  | datetime | YES |
AfterAddDrop |  | bit | NO |
AmCollegeTransferID |  | int | YES |
IsCrossRef |  | bit | YES |
CrossRefAdCourseID |  | int | YES |
MidTermNumericGrade |  | numeric(11, 6) | YES |
MidTermGradeLetterCode |  | char(8) | YES |
MidTermGradeComments |  | varchar(350) | YES |
DateMidTermGradePosted |  | datetime | YES |
IsAudit |  | bit | YES |
AuditEffectiveDate |  | datetime | YES |
IsPassFail |  | bit | NO |
LmsExtractStatus |  | char(1) | YES |
InProgressGrade |  | numeric(9, 2) | YES |
AdCourseFeeSchedID |  | int | YES |
EnrollStatusCredits |  | money | NO |
EnrollStatusHours |  | money | NO |
FaStudentAyPaymentPeriodId |  | int | YES |
RetakeFeeWaived |  | char(1) | NO |
CourseRefundPolicyUsed |  | bit | NO |
ExpDeadlineDate |  | datetime | YES |
ReplacedIncompleteGrade |  | bit | NO |
AmHighSchoolID |  | int | YES |
AmTransferTypeID |  | int | YES |
RetakeTIV2ndCredEarnZeroed |  | bit | NO |
RetakeTIV2ndCredEarnValue |  | money | YES |
UseOnlyRateSchedule |  | bit | YES |
OverrideCourseProgression |  | char(1) | YES |
OutsideCourseWorkHours |  | numeric(9, 2) | NO |
StudentDegreePathwayCourse |  | bit | YES |
AdjustEnrollmentEnabled |  | bit | YES |
CourseAddedFrom |  | char(2) | YES |
AmCollegeTransferAdvanceId |  | int | YES |
AmCollegeTransferRelationId |  | int | YES |
isGlobalCumulativeInclude |  | bit | NO |
IncompleteGradeComment |  | nvarchar(max) | YES |
LDA_FacultyPosted |  | datetime | YES |
AdFinalGradeReasonId |  | int | YES |
ChangedVia |  | nvarchar(2) | YES |
IsMultipleFulfilledCourse |  | bit | YES |
IsPrimaryCourse |  | bit | YES |
MainCourseAdEnrollSchedId |  | int | YES |
RegRelConflictOverride |  | bit | NO |
IsRequirementAdjusted |  | bit | NO |
DropFailedAdEnrollSchedId |  | int | YES |

AdEnrollSched Primary and Unique Keys

Key Name | Key Type | Keys
AdEnrollSched_AdEnrollID_AdTermID_StartDate_DropDate_EndDate_ExpectedEndDate_Status_AdClassSchedID_AdEnrollSchedID_U_N_IDX | Index | AdEnrollID, AdTermID, StartDate, DropDate, EndDate, ExpectedEndDate, Status, AdClassSchedID, AdEnrollSchedID
AdEnrollSched_AdTermID_AdEnrollSchedId_AdEnrollID_Status_SyStudentId_AdCourseId_U_N_IDX | Index | AdTermID, AdEnrollSchedID, AdEnrollID, Status, SyStudentID, AdCourseID
AdEnrollSched_AdEnrollSchedID_U_C_IDX | PrimaryKey | AdEnrollSchedID
AdEnrollSched_Status_adDependentClassSchedID_AdEnrollSchedID_U_N_IDX | Index | Status, AdDependentClassSchedID, AdEnrollSchedID

AdEnrollSched Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication
AmCollegeTransfer | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSched.AmCollegeTransferID_AmCollegeTransfer.AmCollegeTransferID |  |  | AmCollegeTransferID | NO | YES
AdCourseFeeSched | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSched_AdCourseFeeSchedID_AdCourseFeeSched_AdCourseFeeSchedID |  |  | AdCourseFeeSchedID | NO | YES
AdEnroll | Non-Identifying | One To Zero or More | FK_AdEnrollSched_AdEnrollID_AdEnroll_AdEnrollID |  |  | AdEnrollID | NO | YES
AdEnrollRegistration | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSched_AdEnrollRegistrationID_AdEnrollRegistration_AdEnrollRegistrationID |  |  | AdEnrollRegistrationID | NO | YES
AdEnrollSched | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSched_DropFailedAdEnrollSchedId_AdEnrollSched_AdEnrollSchedId |  |  | DropFailedAdEnrollSchedId | NO | YES
FaStudentAYPaymentPeriod | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSched_FaStudentAyPaymentPeriodId_FaStudentAyPaymentPeriod_FaStudentAyPaymentPeriodId |  |  | FaStudentAyPaymentPeriodId | NO | YES
AmHighSchool | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSchedAmHighSchoolID_AmHighSchoolAmHighSchoolID |  |  | AmHighSchoolID | NO | YES
AmTransferType | Non-Identifying | Zero or One to Zero or More | FK_AdEnrollSchedAmTransferTypeID_AmTransferTypeAmTransferTypeID |  |  | AmTransferTypeID | NO | YES

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication
AdAttend | Non-Identifying | One To Zero or More | FK_AdAttend_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdAttendArchive | Non-Identifying | One To Zero or More | FK_AdAttendArchive_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdDegreeAuditUnmatchedTakenCourse | Non-Identifying | One To Zero or More | FK_AdDegreeAuditUnmatchedTakenCourseAdEnrollSchedId_AdEnrollSchedAdEnrollSchedId |  |  |  | NO | YES
AdEnrollDegreeAuditFulfillment | Non-Identifying | One To Zero or More | FK_AdEnrollDegreeAuditFulfillment_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdEnrollLesson | Non-Identifying | One To Zero or More | FK_AdEnrollLesson_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdEnrollLessonRetake | Non-Identifying | One To Zero or More | FK_AdEnrollLessonRetake_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdEnrollSched | Non-Identifying | One To Zero or More | FK_AdEnrollSched_DropFailedAdEnrollSchedId_AdEnrollSched_AdEnrollSchedId |  |  |  | NO | YES
AdEnrollSchedExtend | Non-Identifying | One To Zero or More | FK_AdEnrollSchedExtend_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdEnrollSchedOtherEnroll | Non-Identifying | One To Zero or More | FK_AdEnrollSchedOtherEnroll_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdEnrollSchedProspectTestMapping | Non-Identifying | One To Zero or More | FK_AdEnrollSchedProspectTestMapping_AdEnrollSchedId_AdEnrollSched_AdEnrollSchedId |  |  |  | NO | YES
AdEnrollSchedStatusHistory | Non-Identifying | One To Zero or More | FK_AdEnrollSchedStatusHistory_AdEnrollSChedID_AdEnrollSChed_AdEnrollSChedID |  |  |  | NO | YES
AdGPAStudentCourse | Non-Identifying | One To Zero or More | FK_AdGPAStudentCourseAdEnrollSchedID_AdEnrollSchedAdEnrollSchedID |  |  |  | NO | YES
AdSPECourseCategory | Non-Identifying | One To Zero or More | FK_AdSPECourseCategory_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
AdStudentDegreePathway | Non-Identifying | One To Zero or More | FK_AdStudentDegreePathway_AdEnrollSchedId_AdEnrollSched_AdEnrollSchedId |  |  |  | NO | YES
AdStudentTransferCourses | Identifying | One To Zero or More | FK_AdStudentTransferCourses_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
FaSched | Non-Identifying | One To Zero or More | FK_FaSched_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
SaAutoBillBatchDetailCourse | Identifying | One To Zero or More | FK_SaAutoBillBatchDetailCourse_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES
SaTransCourse | Non-Identifying | One To Zero or More | FK_SaTransCourse_AdEnrollSchedID_AdEnrollSched_AdEnrollSchedID |  |  |  | NO | YES

AdEnrollSched Check Constraints

Check Constraint Name | CheckConstraint
Chk_AdEnrollSched_TransferredCourseDescrip | ([TransferredCourseDescrip] is null or [TransferCredit] = 1)
Chk_AdEnrollSched_TransferredCourseCode | ([TransferredCourseCode] is null or [TransferCredit] = 1)
Chk_AdEnrollSched_MinutesMakeUp | ([Hours] = 0 or [MinutesMakeUp] <= [Hours] * 60)

AdEnrollSched Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group | PRIMARY

AdEnrollSched Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentCourse | NO |  |  |
Physical (Microsoft SQL Server) dbo.AdEnrollSched | NO |  |  |

AdEnrollSched Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Logical | CourseRegistration
Logical | DegreePathway
Logical | Grades/Attendance
Logical | StudentJobPlacement
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Academic Records

AdEnrollSched Data Movement Rules

Name | Type | Rule Text/Value